# -*- coding: utf-8 -*-
# @Time    : 2024/12/9  15:36
# @Author  : Nabby
# @FileName: jasco_forecast_information.py
# @Desc    : 货物预报信息


from app import db, loginmanager
from datetime import datetime


class JascoLogisticsTrajectory(db.Model):
    __tablename__ = 'jasco_logistics_trajectory'
    id = db.Column(db.Integer, primary_key=True)
    status = db.Column(db.String(20), unique=True, comment='进度状态')
    date = db.Column(db.DateTime, comment='日期')
    content = db.Column(db.String(100), comment='轨迹信息')
    location = db.Column(db.String(50), comment='发生位置')
    order_id = db.Column(db.Integer, db.ForeignKey('jasco_order.id'), comment='订单id')
    create_time = db.Column(db.DateTime, default=datetime.now)
    update_time = db.Column(db.DateTime, default=datetime.now, onupdate=datetime.now)



